/*
*
* FrameworkContractInfoExample.java
* @author may
* @date 2021-05-21 09:40:50
*/
package com.steel.yfmall.cloud.assistant.po.goods;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class FrameworkContractInfoExample {
    /**
     * framework_contract_info
     */
    protected String orderByClause;

    /**
     * framework_contract_info
     */
    protected boolean distinct;

    /**
     * framework_contract_info
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:framework_contract_info
     * @Title: FrameworkContractInfoExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-05-21 09:40:50
     */
    public FrameworkContractInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:framework_contract_info
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-05-21 09:40:50
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:framework_contract_info
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-05-21 09:40:50
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:framework_contract_info
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-05-21 09:40:50
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:framework_contract_info
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-05-21 09:40:50
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:framework_contract_info
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-05-21 09:40:50
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:framework_contract_info
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-05-21 09:40:50
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:framework_contract_info
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-05-21 09:40:50
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:framework_contract_info
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-05-21 09:40:50
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:framework_contract_info
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-05-21 09:40:50
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:framework_contract_info
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-05-21 09:40:50
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title framework_contract_info表的实体类
     * @description framework_contract_info
     * @version 1.0
     * @author may
     * @date 2021-05-21 09:40:50
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andCommerceContractNoIsNull() {
            addCriterion("commerce_contract_no is null");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoIsNotNull() {
            addCriterion("commerce_contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoEqualTo(String value) {
            addCriterion("commerce_contract_no =", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotEqualTo(String value) {
            addCriterion("commerce_contract_no <>", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoGreaterThan(String value) {
            addCriterion("commerce_contract_no >", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("commerce_contract_no >=", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLessThan(String value) {
            addCriterion("commerce_contract_no <", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLessThanOrEqualTo(String value) {
            addCriterion("commerce_contract_no <=", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoLike(String value) {
            addCriterion("commerce_contract_no like", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotLike(String value) {
            addCriterion("commerce_contract_no not like", value, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoIn(List<String> values) {
            addCriterion("commerce_contract_no in", values, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotIn(List<String> values) {
            addCriterion("commerce_contract_no not in", values, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoBetween(String value1, String value2) {
            addCriterion("commerce_contract_no between", value1, value2, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andCommerceContractNoNotBetween(String value1, String value2) {
            addCriterion("commerce_contract_no not between", value1, value2, "commerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoIsNull() {
            addCriterion("old_commerce_contract_no is null");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoIsNotNull() {
            addCriterion("old_commerce_contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoEqualTo(String value) {
            addCriterion("old_commerce_contract_no =", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoNotEqualTo(String value) {
            addCriterion("old_commerce_contract_no <>", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoGreaterThan(String value) {
            addCriterion("old_commerce_contract_no >", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("old_commerce_contract_no >=", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoLessThan(String value) {
            addCriterion("old_commerce_contract_no <", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoLessThanOrEqualTo(String value) {
            addCriterion("old_commerce_contract_no <=", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoLike(String value) {
            addCriterion("old_commerce_contract_no like", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoNotLike(String value) {
            addCriterion("old_commerce_contract_no not like", value, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoIn(List<String> values) {
            addCriterion("old_commerce_contract_no in", values, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoNotIn(List<String> values) {
            addCriterion("old_commerce_contract_no not in", values, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoBetween(String value1, String value2) {
            addCriterion("old_commerce_contract_no between", value1, value2, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andOldCommerceContractNoNotBetween(String value1, String value2) {
            addCriterion("old_commerce_contract_no not between", value1, value2, "oldCommerceContractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("contract_no is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("contract_no =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("contract_no <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("contract_no >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("contract_no >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("contract_no <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("contract_no <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("contract_no like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("contract_no not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("contract_no in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("contract_no not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("contract_no between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("contract_no not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNameIsNull() {
            addCriterion("contract_name is null");
            return (Criteria) this;
        }

        public Criteria andContractNameIsNotNull() {
            addCriterion("contract_name is not null");
            return (Criteria) this;
        }

        public Criteria andContractNameEqualTo(String value) {
            addCriterion("contract_name =", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameNotEqualTo(String value) {
            addCriterion("contract_name <>", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameGreaterThan(String value) {
            addCriterion("contract_name >", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameGreaterThanOrEqualTo(String value) {
            addCriterion("contract_name >=", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameLessThan(String value) {
            addCriterion("contract_name <", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameLessThanOrEqualTo(String value) {
            addCriterion("contract_name <=", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameLike(String value) {
            addCriterion("contract_name like", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameNotLike(String value) {
            addCriterion("contract_name not like", value, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameIn(List<String> values) {
            addCriterion("contract_name in", values, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameNotIn(List<String> values) {
            addCriterion("contract_name not in", values, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameBetween(String value1, String value2) {
            addCriterion("contract_name between", value1, value2, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractNameNotBetween(String value1, String value2) {
            addCriterion("contract_name not between", value1, value2, "contractName");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesIsNull() {
            addCriterion("contract_species is null");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesIsNotNull() {
            addCriterion("contract_species is not null");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesEqualTo(String value) {
            addCriterion("contract_species =", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesNotEqualTo(String value) {
            addCriterion("contract_species <>", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesGreaterThan(String value) {
            addCriterion("contract_species >", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesGreaterThanOrEqualTo(String value) {
            addCriterion("contract_species >=", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesLessThan(String value) {
            addCriterion("contract_species <", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesLessThanOrEqualTo(String value) {
            addCriterion("contract_species <=", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesLike(String value) {
            addCriterion("contract_species like", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesNotLike(String value) {
            addCriterion("contract_species not like", value, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesIn(List<String> values) {
            addCriterion("contract_species in", values, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesNotIn(List<String> values) {
            addCriterion("contract_species not in", values, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesBetween(String value1, String value2) {
            addCriterion("contract_species between", value1, value2, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andContractSpeciesNotBetween(String value1, String value2) {
            addCriterion("contract_species not between", value1, value2, "contractSpecies");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoIsNull() {
            addCriterion("kingdee_contract_no is null");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoIsNotNull() {
            addCriterion("kingdee_contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoEqualTo(String value) {
            addCriterion("kingdee_contract_no =", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoNotEqualTo(String value) {
            addCriterion("kingdee_contract_no <>", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoGreaterThan(String value) {
            addCriterion("kingdee_contract_no >", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("kingdee_contract_no >=", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoLessThan(String value) {
            addCriterion("kingdee_contract_no <", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoLessThanOrEqualTo(String value) {
            addCriterion("kingdee_contract_no <=", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoLike(String value) {
            addCriterion("kingdee_contract_no like", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoNotLike(String value) {
            addCriterion("kingdee_contract_no not like", value, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoIn(List<String> values) {
            addCriterion("kingdee_contract_no in", values, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoNotIn(List<String> values) {
            addCriterion("kingdee_contract_no not in", values, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoBetween(String value1, String value2) {
            addCriterion("kingdee_contract_no between", value1, value2, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andKingdeeContractNoNotBetween(String value1, String value2) {
            addCriterion("kingdee_contract_no not between", value1, value2, "kingdeeContractNo");
            return (Criteria) this;
        }

        public Criteria andFramenumIsNull() {
            addCriterion("framenum is null");
            return (Criteria) this;
        }

        public Criteria andFramenumIsNotNull() {
            addCriterion("framenum is not null");
            return (Criteria) this;
        }

        public Criteria andFramenumEqualTo(String value) {
            addCriterion("framenum =", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumNotEqualTo(String value) {
            addCriterion("framenum <>", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumGreaterThan(String value) {
            addCriterion("framenum >", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumGreaterThanOrEqualTo(String value) {
            addCriterion("framenum >=", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumLessThan(String value) {
            addCriterion("framenum <", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumLessThanOrEqualTo(String value) {
            addCriterion("framenum <=", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumLike(String value) {
            addCriterion("framenum like", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumNotLike(String value) {
            addCriterion("framenum not like", value, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumIn(List<String> values) {
            addCriterion("framenum in", values, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumNotIn(List<String> values) {
            addCriterion("framenum not in", values, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumBetween(String value1, String value2) {
            addCriterion("framenum between", value1, value2, "framenum");
            return (Criteria) this;
        }

        public Criteria andFramenumNotBetween(String value1, String value2) {
            addCriterion("framenum not between", value1, value2, "framenum");
            return (Criteria) this;
        }

        public Criteria andCustomerIsNull() {
            addCriterion("customer is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIsNotNull() {
            addCriterion("customer is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerEqualTo(String value) {
            addCriterion("customer =", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotEqualTo(String value) {
            addCriterion("customer <>", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThan(String value) {
            addCriterion("customer >", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThanOrEqualTo(String value) {
            addCriterion("customer >=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThan(String value) {
            addCriterion("customer <", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThanOrEqualTo(String value) {
            addCriterion("customer <=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLike(String value) {
            addCriterion("customer like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotLike(String value) {
            addCriterion("customer not like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerIn(List<String> values) {
            addCriterion("customer in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotIn(List<String> values) {
            addCriterion("customer not in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerBetween(String value1, String value2) {
            addCriterion("customer between", value1, value2, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotBetween(String value1, String value2) {
            addCriterion("customer not between", value1, value2, "customer");
            return (Criteria) this;
        }

        public Criteria andBillstatusIsNull() {
            addCriterion("billstatus is null");
            return (Criteria) this;
        }

        public Criteria andBillstatusIsNotNull() {
            addCriterion("billstatus is not null");
            return (Criteria) this;
        }

        public Criteria andBillstatusEqualTo(String value) {
            addCriterion("billstatus =", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusNotEqualTo(String value) {
            addCriterion("billstatus <>", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusGreaterThan(String value) {
            addCriterion("billstatus >", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusGreaterThanOrEqualTo(String value) {
            addCriterion("billstatus >=", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusLessThan(String value) {
            addCriterion("billstatus <", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusLessThanOrEqualTo(String value) {
            addCriterion("billstatus <=", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusLike(String value) {
            addCriterion("billstatus like", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusNotLike(String value) {
            addCriterion("billstatus not like", value, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusIn(List<String> values) {
            addCriterion("billstatus in", values, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusNotIn(List<String> values) {
            addCriterion("billstatus not in", values, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusBetween(String value1, String value2) {
            addCriterion("billstatus between", value1, value2, "billstatus");
            return (Criteria) this;
        }

        public Criteria andBillstatusNotBetween(String value1, String value2) {
            addCriterion("billstatus not between", value1, value2, "billstatus");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerIsNull() {
            addCriterion("settlecustomer is null");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerIsNotNull() {
            addCriterion("settlecustomer is not null");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerEqualTo(String value) {
            addCriterion("settlecustomer =", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerNotEqualTo(String value) {
            addCriterion("settlecustomer <>", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerGreaterThan(String value) {
            addCriterion("settlecustomer >", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerGreaterThanOrEqualTo(String value) {
            addCriterion("settlecustomer >=", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerLessThan(String value) {
            addCriterion("settlecustomer <", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerLessThanOrEqualTo(String value) {
            addCriterion("settlecustomer <=", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerLike(String value) {
            addCriterion("settlecustomer like", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerNotLike(String value) {
            addCriterion("settlecustomer not like", value, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerIn(List<String> values) {
            addCriterion("settlecustomer in", values, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerNotIn(List<String> values) {
            addCriterion("settlecustomer not in", values, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerBetween(String value1, String value2) {
            addCriterion("settlecustomer between", value1, value2, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andSettlecustomerNotBetween(String value1, String value2) {
            addCriterion("settlecustomer not between", value1, value2, "settlecustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerIsNull() {
            addCriterion("payingcustomer is null");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerIsNotNull() {
            addCriterion("payingcustomer is not null");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerEqualTo(String value) {
            addCriterion("payingcustomer =", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerNotEqualTo(String value) {
            addCriterion("payingcustomer <>", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerGreaterThan(String value) {
            addCriterion("payingcustomer >", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerGreaterThanOrEqualTo(String value) {
            addCriterion("payingcustomer >=", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerLessThan(String value) {
            addCriterion("payingcustomer <", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerLessThanOrEqualTo(String value) {
            addCriterion("payingcustomer <=", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerLike(String value) {
            addCriterion("payingcustomer like", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerNotLike(String value) {
            addCriterion("payingcustomer not like", value, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerIn(List<String> values) {
            addCriterion("payingcustomer in", values, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerNotIn(List<String> values) {
            addCriterion("payingcustomer not in", values, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerBetween(String value1, String value2) {
            addCriterion("payingcustomer between", value1, value2, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayingcustomerNotBetween(String value1, String value2) {
            addCriterion("payingcustomer not between", value1, value2, "payingcustomer");
            return (Criteria) this;
        }

        public Criteria andPayty1stIsNull() {
            addCriterion("payty1st is null");
            return (Criteria) this;
        }

        public Criteria andPayty1stIsNotNull() {
            addCriterion("payty1st is not null");
            return (Criteria) this;
        }

        public Criteria andPayty1stEqualTo(String value) {
            addCriterion("payty1st =", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stNotEqualTo(String value) {
            addCriterion("payty1st <>", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stGreaterThan(String value) {
            addCriterion("payty1st >", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stGreaterThanOrEqualTo(String value) {
            addCriterion("payty1st >=", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stLessThan(String value) {
            addCriterion("payty1st <", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stLessThanOrEqualTo(String value) {
            addCriterion("payty1st <=", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stLike(String value) {
            addCriterion("payty1st like", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stNotLike(String value) {
            addCriterion("payty1st not like", value, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stIn(List<String> values) {
            addCriterion("payty1st in", values, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stNotIn(List<String> values) {
            addCriterion("payty1st not in", values, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stBetween(String value1, String value2) {
            addCriterion("payty1st between", value1, value2, "payty1st");
            return (Criteria) this;
        }

        public Criteria andPayty1stNotBetween(String value1, String value2) {
            addCriterion("payty1st not between", value1, value2, "payty1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stIsNull() {
            addCriterion("contactperson1st is null");
            return (Criteria) this;
        }

        public Criteria andContactperson1stIsNotNull() {
            addCriterion("contactperson1st is not null");
            return (Criteria) this;
        }

        public Criteria andContactperson1stEqualTo(String value) {
            addCriterion("contactperson1st =", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stNotEqualTo(String value) {
            addCriterion("contactperson1st <>", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stGreaterThan(String value) {
            addCriterion("contactperson1st >", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stGreaterThanOrEqualTo(String value) {
            addCriterion("contactperson1st >=", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stLessThan(String value) {
            addCriterion("contactperson1st <", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stLessThanOrEqualTo(String value) {
            addCriterion("contactperson1st <=", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stLike(String value) {
            addCriterion("contactperson1st like", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stNotLike(String value) {
            addCriterion("contactperson1st not like", value, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stIn(List<String> values) {
            addCriterion("contactperson1st in", values, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stNotIn(List<String> values) {
            addCriterion("contactperson1st not in", values, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stBetween(String value1, String value2) {
            addCriterion("contactperson1st between", value1, value2, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andContactperson1stNotBetween(String value1, String value2) {
            addCriterion("contactperson1st not between", value1, value2, "contactperson1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stIsNull() {
            addCriterion("phone1st is null");
            return (Criteria) this;
        }

        public Criteria andPhone1stIsNotNull() {
            addCriterion("phone1st is not null");
            return (Criteria) this;
        }

        public Criteria andPhone1stEqualTo(String value) {
            addCriterion("phone1st =", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stNotEqualTo(String value) {
            addCriterion("phone1st <>", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stGreaterThan(String value) {
            addCriterion("phone1st >", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stGreaterThanOrEqualTo(String value) {
            addCriterion("phone1st >=", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stLessThan(String value) {
            addCriterion("phone1st <", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stLessThanOrEqualTo(String value) {
            addCriterion("phone1st <=", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stLike(String value) {
            addCriterion("phone1st like", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stNotLike(String value) {
            addCriterion("phone1st not like", value, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stIn(List<String> values) {
            addCriterion("phone1st in", values, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stNotIn(List<String> values) {
            addCriterion("phone1st not in", values, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stBetween(String value1, String value2) {
            addCriterion("phone1st between", value1, value2, "phone1st");
            return (Criteria) this;
        }

        public Criteria andPhone1stNotBetween(String value1, String value2) {
            addCriterion("phone1st not between", value1, value2, "phone1st");
            return (Criteria) this;
        }

        public Criteria andParty2ndIsNull() {
            addCriterion("party2nd is null");
            return (Criteria) this;
        }

        public Criteria andParty2ndIsNotNull() {
            addCriterion("party2nd is not null");
            return (Criteria) this;
        }

        public Criteria andParty2ndEqualTo(String value) {
            addCriterion("party2nd =", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndNotEqualTo(String value) {
            addCriterion("party2nd <>", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndGreaterThan(String value) {
            addCriterion("party2nd >", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndGreaterThanOrEqualTo(String value) {
            addCriterion("party2nd >=", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndLessThan(String value) {
            addCriterion("party2nd <", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndLessThanOrEqualTo(String value) {
            addCriterion("party2nd <=", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndLike(String value) {
            addCriterion("party2nd like", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndNotLike(String value) {
            addCriterion("party2nd not like", value, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndIn(List<String> values) {
            addCriterion("party2nd in", values, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndNotIn(List<String> values) {
            addCriterion("party2nd not in", values, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndBetween(String value1, String value2) {
            addCriterion("party2nd between", value1, value2, "party2nd");
            return (Criteria) this;
        }

        public Criteria andParty2ndNotBetween(String value1, String value2) {
            addCriterion("party2nd not between", value1, value2, "party2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndIsNull() {
            addCriterion("contactperson2nd is null");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndIsNotNull() {
            addCriterion("contactperson2nd is not null");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndEqualTo(String value) {
            addCriterion("contactperson2nd =", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndNotEqualTo(String value) {
            addCriterion("contactperson2nd <>", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndGreaterThan(String value) {
            addCriterion("contactperson2nd >", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndGreaterThanOrEqualTo(String value) {
            addCriterion("contactperson2nd >=", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndLessThan(String value) {
            addCriterion("contactperson2nd <", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndLessThanOrEqualTo(String value) {
            addCriterion("contactperson2nd <=", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndLike(String value) {
            addCriterion("contactperson2nd like", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndNotLike(String value) {
            addCriterion("contactperson2nd not like", value, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndIn(List<String> values) {
            addCriterion("contactperson2nd in", values, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndNotIn(List<String> values) {
            addCriterion("contactperson2nd not in", values, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndBetween(String value1, String value2) {
            addCriterion("contactperson2nd between", value1, value2, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andContactperson2ndNotBetween(String value1, String value2) {
            addCriterion("contactperson2nd not between", value1, value2, "contactperson2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndIsNull() {
            addCriterion("phone2nd is null");
            return (Criteria) this;
        }

        public Criteria andPhone2ndIsNotNull() {
            addCriterion("phone2nd is not null");
            return (Criteria) this;
        }

        public Criteria andPhone2ndEqualTo(String value) {
            addCriterion("phone2nd =", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndNotEqualTo(String value) {
            addCriterion("phone2nd <>", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndGreaterThan(String value) {
            addCriterion("phone2nd >", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndGreaterThanOrEqualTo(String value) {
            addCriterion("phone2nd >=", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndLessThan(String value) {
            addCriterion("phone2nd <", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndLessThanOrEqualTo(String value) {
            addCriterion("phone2nd <=", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndLike(String value) {
            addCriterion("phone2nd like", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndNotLike(String value) {
            addCriterion("phone2nd not like", value, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndIn(List<String> values) {
            addCriterion("phone2nd in", values, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndNotIn(List<String> values) {
            addCriterion("phone2nd not in", values, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndBetween(String value1, String value2) {
            addCriterion("phone2nd between", value1, value2, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPhone2ndNotBetween(String value1, String value2) {
            addCriterion("phone2nd not between", value1, value2, "phone2nd");
            return (Criteria) this;
        }

        public Criteria andPartcIsNull() {
            addCriterion("partc is null");
            return (Criteria) this;
        }

        public Criteria andPartcIsNotNull() {
            addCriterion("partc is not null");
            return (Criteria) this;
        }

        public Criteria andPartcEqualTo(String value) {
            addCriterion("partc =", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcNotEqualTo(String value) {
            addCriterion("partc <>", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcGreaterThan(String value) {
            addCriterion("partc >", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcGreaterThanOrEqualTo(String value) {
            addCriterion("partc >=", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcLessThan(String value) {
            addCriterion("partc <", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcLessThanOrEqualTo(String value) {
            addCriterion("partc <=", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcLike(String value) {
            addCriterion("partc like", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcNotLike(String value) {
            addCriterion("partc not like", value, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcIn(List<String> values) {
            addCriterion("partc in", values, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcNotIn(List<String> values) {
            addCriterion("partc not in", values, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcBetween(String value1, String value2) {
            addCriterion("partc between", value1, value2, "partc");
            return (Criteria) this;
        }

        public Criteria andPartcNotBetween(String value1, String value2) {
            addCriterion("partc not between", value1, value2, "partc");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageIsNull() {
            addCriterion("remote_storage is null");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageIsNotNull() {
            addCriterion("remote_storage is not null");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageEqualTo(String value) {
            addCriterion("remote_storage =", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageNotEqualTo(String value) {
            addCriterion("remote_storage <>", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageGreaterThan(String value) {
            addCriterion("remote_storage >", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageGreaterThanOrEqualTo(String value) {
            addCriterion("remote_storage >=", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageLessThan(String value) {
            addCriterion("remote_storage <", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageLessThanOrEqualTo(String value) {
            addCriterion("remote_storage <=", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageLike(String value) {
            addCriterion("remote_storage like", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageNotLike(String value) {
            addCriterion("remote_storage not like", value, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageIn(List<String> values) {
            addCriterion("remote_storage in", values, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageNotIn(List<String> values) {
            addCriterion("remote_storage not in", values, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageBetween(String value1, String value2) {
            addCriterion("remote_storage between", value1, value2, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andRemoteStorageNotBetween(String value1, String value2) {
            addCriterion("remote_storage not between", value1, value2, "remoteStorage");
            return (Criteria) this;
        }

        public Criteria andEndUserIsNull() {
            addCriterion("end_user is null");
            return (Criteria) this;
        }

        public Criteria andEndUserIsNotNull() {
            addCriterion("end_user is not null");
            return (Criteria) this;
        }

        public Criteria andEndUserEqualTo(String value) {
            addCriterion("end_user =", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserNotEqualTo(String value) {
            addCriterion("end_user <>", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserGreaterThan(String value) {
            addCriterion("end_user >", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserGreaterThanOrEqualTo(String value) {
            addCriterion("end_user >=", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserLessThan(String value) {
            addCriterion("end_user <", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserLessThanOrEqualTo(String value) {
            addCriterion("end_user <=", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserLike(String value) {
            addCriterion("end_user like", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserNotLike(String value) {
            addCriterion("end_user not like", value, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserIn(List<String> values) {
            addCriterion("end_user in", values, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserNotIn(List<String> values) {
            addCriterion("end_user not in", values, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserBetween(String value1, String value2) {
            addCriterion("end_user between", value1, value2, "endUser");
            return (Criteria) this;
        }

        public Criteria andEndUserNotBetween(String value1, String value2) {
            addCriterion("end_user not between", value1, value2, "endUser");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractIsNull() {
            addCriterion("type_of_contract is null");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractIsNotNull() {
            addCriterion("type_of_contract is not null");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractEqualTo(String value) {
            addCriterion("type_of_contract =", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractNotEqualTo(String value) {
            addCriterion("type_of_contract <>", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractGreaterThan(String value) {
            addCriterion("type_of_contract >", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractGreaterThanOrEqualTo(String value) {
            addCriterion("type_of_contract >=", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractLessThan(String value) {
            addCriterion("type_of_contract <", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractLessThanOrEqualTo(String value) {
            addCriterion("type_of_contract <=", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractLike(String value) {
            addCriterion("type_of_contract like", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractNotLike(String value) {
            addCriterion("type_of_contract not like", value, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractIn(List<String> values) {
            addCriterion("type_of_contract in", values, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractNotIn(List<String> values) {
            addCriterion("type_of_contract not in", values, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractBetween(String value1, String value2) {
            addCriterion("type_of_contract between", value1, value2, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andTypeOfContractNotBetween(String value1, String value2) {
            addCriterion("type_of_contract not between", value1, value2, "typeOfContract");
            return (Criteria) this;
        }

        public Criteria andInputcodeIsNull() {
            addCriterion("inputcode is null");
            return (Criteria) this;
        }

        public Criteria andInputcodeIsNotNull() {
            addCriterion("inputcode is not null");
            return (Criteria) this;
        }

        public Criteria andInputcodeEqualTo(String value) {
            addCriterion("inputcode =", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeNotEqualTo(String value) {
            addCriterion("inputcode <>", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeGreaterThan(String value) {
            addCriterion("inputcode >", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeGreaterThanOrEqualTo(String value) {
            addCriterion("inputcode >=", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeLessThan(String value) {
            addCriterion("inputcode <", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeLessThanOrEqualTo(String value) {
            addCriterion("inputcode <=", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeLike(String value) {
            addCriterion("inputcode like", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeNotLike(String value) {
            addCriterion("inputcode not like", value, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeIn(List<String> values) {
            addCriterion("inputcode in", values, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeNotIn(List<String> values) {
            addCriterion("inputcode not in", values, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeBetween(String value1, String value2) {
            addCriterion("inputcode between", value1, value2, "inputcode");
            return (Criteria) this;
        }

        public Criteria andInputcodeNotBetween(String value1, String value2) {
            addCriterion("inputcode not between", value1, value2, "inputcode");
            return (Criteria) this;
        }

        public Criteria andContractVerIsNull() {
            addCriterion("contract_ver is null");
            return (Criteria) this;
        }

        public Criteria andContractVerIsNotNull() {
            addCriterion("contract_ver is not null");
            return (Criteria) this;
        }

        public Criteria andContractVerEqualTo(String value) {
            addCriterion("contract_ver =", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotEqualTo(String value) {
            addCriterion("contract_ver <>", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerGreaterThan(String value) {
            addCriterion("contract_ver >", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerGreaterThanOrEqualTo(String value) {
            addCriterion("contract_ver >=", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLessThan(String value) {
            addCriterion("contract_ver <", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLessThanOrEqualTo(String value) {
            addCriterion("contract_ver <=", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerLike(String value) {
            addCriterion("contract_ver like", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotLike(String value) {
            addCriterion("contract_ver not like", value, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerIn(List<String> values) {
            addCriterion("contract_ver in", values, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotIn(List<String> values) {
            addCriterion("contract_ver not in", values, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerBetween(String value1, String value2) {
            addCriterion("contract_ver between", value1, value2, "contractVer");
            return (Criteria) this;
        }

        public Criteria andContractVerNotBetween(String value1, String value2) {
            addCriterion("contract_ver not between", value1, value2, "contractVer");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNull() {
            addCriterion("cust_no is null");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNotNull() {
            addCriterion("cust_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustNoEqualTo(String value) {
            addCriterion("cust_no =", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotEqualTo(String value) {
            addCriterion("cust_no <>", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThan(String value) {
            addCriterion("cust_no >", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThanOrEqualTo(String value) {
            addCriterion("cust_no >=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThan(String value) {
            addCriterion("cust_no <", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThanOrEqualTo(String value) {
            addCriterion("cust_no <=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLike(String value) {
            addCriterion("cust_no like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotLike(String value) {
            addCriterion("cust_no not like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoIn(List<String> values) {
            addCriterion("cust_no in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotIn(List<String> values) {
            addCriterion("cust_no not in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoBetween(String value1, String value2) {
            addCriterion("cust_no between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotBetween(String value1, String value2) {
            addCriterion("cust_no not between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andSignedSiteIsNull() {
            addCriterion("signed_site is null");
            return (Criteria) this;
        }

        public Criteria andSignedSiteIsNotNull() {
            addCriterion("signed_site is not null");
            return (Criteria) this;
        }

        public Criteria andSignedSiteEqualTo(String value) {
            addCriterion("signed_site =", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteNotEqualTo(String value) {
            addCriterion("signed_site <>", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteGreaterThan(String value) {
            addCriterion("signed_site >", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteGreaterThanOrEqualTo(String value) {
            addCriterion("signed_site >=", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteLessThan(String value) {
            addCriterion("signed_site <", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteLessThanOrEqualTo(String value) {
            addCriterion("signed_site <=", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteLike(String value) {
            addCriterion("signed_site like", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteNotLike(String value) {
            addCriterion("signed_site not like", value, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteIn(List<String> values) {
            addCriterion("signed_site in", values, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteNotIn(List<String> values) {
            addCriterion("signed_site not in", values, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteBetween(String value1, String value2) {
            addCriterion("signed_site between", value1, value2, "signedSite");
            return (Criteria) this;
        }

        public Criteria andSignedSiteNotBetween(String value1, String value2) {
            addCriterion("signed_site not between", value1, value2, "signedSite");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNull() {
            addCriterion("contract_type is null");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNotNull() {
            addCriterion("contract_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractTypeEqualTo(String value) {
            addCriterion("contract_type =", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotEqualTo(String value) {
            addCriterion("contract_type <>", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThan(String value) {
            addCriterion("contract_type >", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_type >=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThan(String value) {
            addCriterion("contract_type <", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_type <=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLike(String value) {
            addCriterion("contract_type like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotLike(String value) {
            addCriterion("contract_type not like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeIn(List<String> values) {
            addCriterion("contract_type in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotIn(List<String> values) {
            addCriterion("contract_type not in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeBetween(String value1, String value2) {
            addCriterion("contract_type between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotBetween(String value1, String value2) {
            addCriterion("contract_type not between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeIsNull() {
            addCriterion("contract_new_type is null");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeIsNotNull() {
            addCriterion("contract_new_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeEqualTo(String value) {
            addCriterion("contract_new_type =", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeNotEqualTo(String value) {
            addCriterion("contract_new_type <>", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeGreaterThan(String value) {
            addCriterion("contract_new_type >", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_new_type >=", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeLessThan(String value) {
            addCriterion("contract_new_type <", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_new_type <=", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeLike(String value) {
            addCriterion("contract_new_type like", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeNotLike(String value) {
            addCriterion("contract_new_type not like", value, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeIn(List<String> values) {
            addCriterion("contract_new_type in", values, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeNotIn(List<String> values) {
            addCriterion("contract_new_type not in", values, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeBetween(String value1, String value2) {
            addCriterion("contract_new_type between", value1, value2, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andContractNewTypeNotBetween(String value1, String value2) {
            addCriterion("contract_new_type not between", value1, value2, "contractNewType");
            return (Criteria) this;
        }

        public Criteria andBizmodeIsNull() {
            addCriterion("bizmode is null");
            return (Criteria) this;
        }

        public Criteria andBizmodeIsNotNull() {
            addCriterion("bizmode is not null");
            return (Criteria) this;
        }

        public Criteria andBizmodeEqualTo(String value) {
            addCriterion("bizmode =", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeNotEqualTo(String value) {
            addCriterion("bizmode <>", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeGreaterThan(String value) {
            addCriterion("bizmode >", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeGreaterThanOrEqualTo(String value) {
            addCriterion("bizmode >=", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeLessThan(String value) {
            addCriterion("bizmode <", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeLessThanOrEqualTo(String value) {
            addCriterion("bizmode <=", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeLike(String value) {
            addCriterion("bizmode like", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeNotLike(String value) {
            addCriterion("bizmode not like", value, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeIn(List<String> values) {
            addCriterion("bizmode in", values, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeNotIn(List<String> values) {
            addCriterion("bizmode not in", values, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeBetween(String value1, String value2) {
            addCriterion("bizmode between", value1, value2, "bizmode");
            return (Criteria) this;
        }

        public Criteria andBizmodeNotBetween(String value1, String value2) {
            addCriterion("bizmode not between", value1, value2, "bizmode");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeIsNull() {
            addCriterion("contract_sales_type is null");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeIsNotNull() {
            addCriterion("contract_sales_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeEqualTo(String value) {
            addCriterion("contract_sales_type =", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeNotEqualTo(String value) {
            addCriterion("contract_sales_type <>", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeGreaterThan(String value) {
            addCriterion("contract_sales_type >", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_sales_type >=", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeLessThan(String value) {
            addCriterion("contract_sales_type <", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_sales_type <=", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeLike(String value) {
            addCriterion("contract_sales_type like", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeNotLike(String value) {
            addCriterion("contract_sales_type not like", value, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeIn(List<String> values) {
            addCriterion("contract_sales_type in", values, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeNotIn(List<String> values) {
            addCriterion("contract_sales_type not in", values, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeBetween(String value1, String value2) {
            addCriterion("contract_sales_type between", value1, value2, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andContractSalesTypeNotBetween(String value1, String value2) {
            addCriterion("contract_sales_type not between", value1, value2, "contractSalesType");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeIsNull() {
            addCriterion("cantract_biztime is null");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeIsNotNull() {
            addCriterion("cantract_biztime is not null");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeEqualTo(Date value) {
            addCriterion("cantract_biztime =", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeNotEqualTo(Date value) {
            addCriterion("cantract_biztime <>", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeGreaterThan(Date value) {
            addCriterion("cantract_biztime >", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeGreaterThanOrEqualTo(Date value) {
            addCriterion("cantract_biztime >=", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeLessThan(Date value) {
            addCriterion("cantract_biztime <", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeLessThanOrEqualTo(Date value) {
            addCriterion("cantract_biztime <=", value, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeIn(List<Date> values) {
            addCriterion("cantract_biztime in", values, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeNotIn(List<Date> values) {
            addCriterion("cantract_biztime not in", values, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeBetween(Date value1, Date value2) {
            addCriterion("cantract_biztime between", value1, value2, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andCantractBiztimeNotBetween(Date value1, Date value2) {
            addCriterion("cantract_biztime not between", value1, value2, "cantractBiztime");
            return (Criteria) this;
        }

        public Criteria andContractDateIsNull() {
            addCriterion("contract_date is null");
            return (Criteria) this;
        }

        public Criteria andContractDateIsNotNull() {
            addCriterion("contract_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractDateEqualTo(Date value) {
            addCriterionForJDBCDate("contract_date =", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("contract_date <>", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateGreaterThan(Date value) {
            addCriterionForJDBCDate("contract_date >", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_date >=", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateLessThan(Date value) {
            addCriterionForJDBCDate("contract_date <", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_date <=", value, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateIn(List<Date> values) {
            addCriterionForJDBCDate("contract_date in", values, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("contract_date not in", values, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_date between", value1, value2, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_date not between", value1, value2, "contractDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNull() {
            addCriterion("contract_end_date is null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNotNull() {
            addCriterion("contract_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date =", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date <>", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThan(Date value) {
            addCriterionForJDBCDate("contract_end_date >", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date >=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThan(Date value) {
            addCriterionForJDBCDate("contract_end_date <", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("contract_end_date <=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIn(List<Date> values) {
            addCriterionForJDBCDate("contract_end_date in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("contract_end_date not in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_end_date between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("contract_end_date not between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andProdClassIsNull() {
            addCriterion("prod_class is null");
            return (Criteria) this;
        }

        public Criteria andProdClassIsNotNull() {
            addCriterion("prod_class is not null");
            return (Criteria) this;
        }

        public Criteria andProdClassEqualTo(String value) {
            addCriterion("prod_class =", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotEqualTo(String value) {
            addCriterion("prod_class <>", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassGreaterThan(String value) {
            addCriterion("prod_class >", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassGreaterThanOrEqualTo(String value) {
            addCriterion("prod_class >=", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLessThan(String value) {
            addCriterion("prod_class <", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLessThanOrEqualTo(String value) {
            addCriterion("prod_class <=", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassLike(String value) {
            addCriterion("prod_class like", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotLike(String value) {
            addCriterion("prod_class not like", value, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassIn(List<String> values) {
            addCriterion("prod_class in", values, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotIn(List<String> values) {
            addCriterion("prod_class not in", values, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassBetween(String value1, String value2) {
            addCriterion("prod_class between", value1, value2, "prodClass");
            return (Criteria) this;
        }

        public Criteria andProdClassNotBetween(String value1, String value2) {
            addCriterion("prod_class not between", value1, value2, "prodClass");
            return (Criteria) this;
        }

        public Criteria andSettletypeIsNull() {
            addCriterion("settletype is null");
            return (Criteria) this;
        }

        public Criteria andSettletypeIsNotNull() {
            addCriterion("settletype is not null");
            return (Criteria) this;
        }

        public Criteria andSettletypeEqualTo(String value) {
            addCriterion("settletype =", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeNotEqualTo(String value) {
            addCriterion("settletype <>", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeGreaterThan(String value) {
            addCriterion("settletype >", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeGreaterThanOrEqualTo(String value) {
            addCriterion("settletype >=", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeLessThan(String value) {
            addCriterion("settletype <", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeLessThanOrEqualTo(String value) {
            addCriterion("settletype <=", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeLike(String value) {
            addCriterion("settletype like", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeNotLike(String value) {
            addCriterion("settletype not like", value, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeIn(List<String> values) {
            addCriterion("settletype in", values, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeNotIn(List<String> values) {
            addCriterion("settletype not in", values, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeBetween(String value1, String value2) {
            addCriterion("settletype between", value1, value2, "settletype");
            return (Criteria) this;
        }

        public Criteria andSettletypeNotBetween(String value1, String value2) {
            addCriterion("settletype not between", value1, value2, "settletype");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyIsNull() {
            addCriterion("is_pricepolicy is null");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyIsNotNull() {
            addCriterion("is_pricepolicy is not null");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyEqualTo(String value) {
            addCriterion("is_pricepolicy =", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyNotEqualTo(String value) {
            addCriterion("is_pricepolicy <>", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyGreaterThan(String value) {
            addCriterion("is_pricepolicy >", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyGreaterThanOrEqualTo(String value) {
            addCriterion("is_pricepolicy >=", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyLessThan(String value) {
            addCriterion("is_pricepolicy <", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyLessThanOrEqualTo(String value) {
            addCriterion("is_pricepolicy <=", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyLike(String value) {
            addCriterion("is_pricepolicy like", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyNotLike(String value) {
            addCriterion("is_pricepolicy not like", value, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyIn(List<String> values) {
            addCriterion("is_pricepolicy in", values, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyNotIn(List<String> values) {
            addCriterion("is_pricepolicy not in", values, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyBetween(String value1, String value2) {
            addCriterion("is_pricepolicy between", value1, value2, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andIsPricepolicyNotBetween(String value1, String value2) {
            addCriterion("is_pricepolicy not between", value1, value2, "isPricepolicy");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNull() {
            addCriterion("org_name is null");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNotNull() {
            addCriterion("org_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrgNameEqualTo(String value) {
            addCriterion("org_name =", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotEqualTo(String value) {
            addCriterion("org_name <>", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThan(String value) {
            addCriterion("org_name >", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThanOrEqualTo(String value) {
            addCriterion("org_name >=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThan(String value) {
            addCriterion("org_name <", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThanOrEqualTo(String value) {
            addCriterion("org_name <=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLike(String value) {
            addCriterion("org_name like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotLike(String value) {
            addCriterion("org_name not like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameIn(List<String> values) {
            addCriterion("org_name in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotIn(List<String> values) {
            addCriterion("org_name not in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameBetween(String value1, String value2) {
            addCriterion("org_name between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotBetween(String value1, String value2) {
            addCriterion("org_name not between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIsNull() {
            addCriterion("production_scheduling is null");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIsNotNull() {
            addCriterion("production_scheduling is not null");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingEqualTo(String value) {
            addCriterion("production_scheduling =", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotEqualTo(String value) {
            addCriterion("production_scheduling <>", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingGreaterThan(String value) {
            addCriterion("production_scheduling >", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingGreaterThanOrEqualTo(String value) {
            addCriterion("production_scheduling >=", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingLessThan(String value) {
            addCriterion("production_scheduling <", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingLessThanOrEqualTo(String value) {
            addCriterion("production_scheduling <=", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingLike(String value) {
            addCriterion("production_scheduling like", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotLike(String value) {
            addCriterion("production_scheduling not like", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIn(List<String> values) {
            addCriterion("production_scheduling in", values, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotIn(List<String> values) {
            addCriterion("production_scheduling not in", values, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingBetween(String value1, String value2) {
            addCriterion("production_scheduling between", value1, value2, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotBetween(String value1, String value2) {
            addCriterion("production_scheduling not between", value1, value2, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andPriceMethodIsNull() {
            addCriterion("price_method is null");
            return (Criteria) this;
        }

        public Criteria andPriceMethodIsNotNull() {
            addCriterion("price_method is not null");
            return (Criteria) this;
        }

        public Criteria andPriceMethodEqualTo(String value) {
            addCriterion("price_method =", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodNotEqualTo(String value) {
            addCriterion("price_method <>", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodGreaterThan(String value) {
            addCriterion("price_method >", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodGreaterThanOrEqualTo(String value) {
            addCriterion("price_method >=", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodLessThan(String value) {
            addCriterion("price_method <", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodLessThanOrEqualTo(String value) {
            addCriterion("price_method <=", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodLike(String value) {
            addCriterion("price_method like", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodNotLike(String value) {
            addCriterion("price_method not like", value, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodIn(List<String> values) {
            addCriterion("price_method in", values, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodNotIn(List<String> values) {
            addCriterion("price_method not in", values, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodBetween(String value1, String value2) {
            addCriterion("price_method between", value1, value2, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andPriceMethodNotBetween(String value1, String value2) {
            addCriterion("price_method not between", value1, value2, "priceMethod");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdIsNull() {
            addCriterion("sale_area_id is null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdIsNotNull() {
            addCriterion("sale_area_id is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdEqualTo(String value) {
            addCriterion("sale_area_id =", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdNotEqualTo(String value) {
            addCriterion("sale_area_id <>", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdGreaterThan(String value) {
            addCriterion("sale_area_id >", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdGreaterThanOrEqualTo(String value) {
            addCriterion("sale_area_id >=", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdLessThan(String value) {
            addCriterion("sale_area_id <", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdLessThanOrEqualTo(String value) {
            addCriterion("sale_area_id <=", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdLike(String value) {
            addCriterion("sale_area_id like", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdNotLike(String value) {
            addCriterion("sale_area_id not like", value, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdIn(List<String> values) {
            addCriterion("sale_area_id in", values, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdNotIn(List<String> values) {
            addCriterion("sale_area_id not in", values, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdBetween(String value1, String value2) {
            addCriterion("sale_area_id between", value1, value2, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaIdNotBetween(String value1, String value2) {
            addCriterion("sale_area_id not between", value1, value2, "saleAreaId");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIsNull() {
            addCriterion("sale_area_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIsNotNull() {
            addCriterion("sale_area_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameEqualTo(String value) {
            addCriterion("sale_area_name =", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotEqualTo(String value) {
            addCriterion("sale_area_name <>", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameGreaterThan(String value) {
            addCriterion("sale_area_name >", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_area_name >=", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLessThan(String value) {
            addCriterion("sale_area_name <", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLessThanOrEqualTo(String value) {
            addCriterion("sale_area_name <=", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLike(String value) {
            addCriterion("sale_area_name like", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotLike(String value) {
            addCriterion("sale_area_name not like", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIn(List<String> values) {
            addCriterion("sale_area_name in", values, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotIn(List<String> values) {
            addCriterion("sale_area_name not in", values, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameBetween(String value1, String value2) {
            addCriterion("sale_area_name between", value1, value2, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotBetween(String value1, String value2) {
            addCriterion("sale_area_name not between", value1, value2, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeIsNull() {
            addCriterion("supply_type is null");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeIsNotNull() {
            addCriterion("supply_type is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeEqualTo(String value) {
            addCriterion("supply_type =", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeNotEqualTo(String value) {
            addCriterion("supply_type <>", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeGreaterThan(String value) {
            addCriterion("supply_type >", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("supply_type >=", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeLessThan(String value) {
            addCriterion("supply_type <", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeLessThanOrEqualTo(String value) {
            addCriterion("supply_type <=", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeLike(String value) {
            addCriterion("supply_type like", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeNotLike(String value) {
            addCriterion("supply_type not like", value, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeIn(List<String> values) {
            addCriterion("supply_type in", values, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeNotIn(List<String> values) {
            addCriterion("supply_type not in", values, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeBetween(String value1, String value2) {
            addCriterion("supply_type between", value1, value2, "supplyType");
            return (Criteria) this;
        }

        public Criteria andSupplyTypeNotBetween(String value1, String value2) {
            addCriterion("supply_type not between", value1, value2, "supplyType");
            return (Criteria) this;
        }

        public Criteria andBdIdIsNull() {
            addCriterion("bd_id is null");
            return (Criteria) this;
        }

        public Criteria andBdIdIsNotNull() {
            addCriterion("bd_id is not null");
            return (Criteria) this;
        }

        public Criteria andBdIdEqualTo(String value) {
            addCriterion("bd_id =", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdNotEqualTo(String value) {
            addCriterion("bd_id <>", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdGreaterThan(String value) {
            addCriterion("bd_id >", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdGreaterThanOrEqualTo(String value) {
            addCriterion("bd_id >=", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdLessThan(String value) {
            addCriterion("bd_id <", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdLessThanOrEqualTo(String value) {
            addCriterion("bd_id <=", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdLike(String value) {
            addCriterion("bd_id like", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdNotLike(String value) {
            addCriterion("bd_id not like", value, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdIn(List<String> values) {
            addCriterion("bd_id in", values, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdNotIn(List<String> values) {
            addCriterion("bd_id not in", values, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdBetween(String value1, String value2) {
            addCriterion("bd_id between", value1, value2, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdIdNotBetween(String value1, String value2) {
            addCriterion("bd_id not between", value1, value2, "bdId");
            return (Criteria) this;
        }

        public Criteria andBdNameIsNull() {
            addCriterion("bd_name is null");
            return (Criteria) this;
        }

        public Criteria andBdNameIsNotNull() {
            addCriterion("bd_name is not null");
            return (Criteria) this;
        }

        public Criteria andBdNameEqualTo(String value) {
            addCriterion("bd_name =", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameNotEqualTo(String value) {
            addCriterion("bd_name <>", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameGreaterThan(String value) {
            addCriterion("bd_name >", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameGreaterThanOrEqualTo(String value) {
            addCriterion("bd_name >=", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameLessThan(String value) {
            addCriterion("bd_name <", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameLessThanOrEqualTo(String value) {
            addCriterion("bd_name <=", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameLike(String value) {
            addCriterion("bd_name like", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameNotLike(String value) {
            addCriterion("bd_name not like", value, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameIn(List<String> values) {
            addCriterion("bd_name in", values, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameNotIn(List<String> values) {
            addCriterion("bd_name not in", values, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameBetween(String value1, String value2) {
            addCriterion("bd_name between", value1, value2, "bdName");
            return (Criteria) this;
        }

        public Criteria andBdNameNotBetween(String value1, String value2) {
            addCriterion("bd_name not between", value1, value2, "bdName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdIsNull() {
            addCriterion("sale_group_id is null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdIsNotNull() {
            addCriterion("sale_group_id is not null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdEqualTo(String value) {
            addCriterion("sale_group_id =", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdNotEqualTo(String value) {
            addCriterion("sale_group_id <>", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdGreaterThan(String value) {
            addCriterion("sale_group_id >", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdGreaterThanOrEqualTo(String value) {
            addCriterion("sale_group_id >=", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdLessThan(String value) {
            addCriterion("sale_group_id <", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdLessThanOrEqualTo(String value) {
            addCriterion("sale_group_id <=", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdLike(String value) {
            addCriterion("sale_group_id like", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdNotLike(String value) {
            addCriterion("sale_group_id not like", value, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdIn(List<String> values) {
            addCriterion("sale_group_id in", values, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdNotIn(List<String> values) {
            addCriterion("sale_group_id not in", values, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdBetween(String value1, String value2) {
            addCriterion("sale_group_id between", value1, value2, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupIdNotBetween(String value1, String value2) {
            addCriterion("sale_group_id not between", value1, value2, "saleGroupId");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIsNull() {
            addCriterion("sale_group_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIsNotNull() {
            addCriterion("sale_group_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameEqualTo(String value) {
            addCriterion("sale_group_name =", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotEqualTo(String value) {
            addCriterion("sale_group_name <>", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameGreaterThan(String value) {
            addCriterion("sale_group_name >", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_group_name >=", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLessThan(String value) {
            addCriterion("sale_group_name <", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLessThanOrEqualTo(String value) {
            addCriterion("sale_group_name <=", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLike(String value) {
            addCriterion("sale_group_name like", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotLike(String value) {
            addCriterion("sale_group_name not like", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIn(List<String> values) {
            addCriterion("sale_group_name in", values, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotIn(List<String> values) {
            addCriterion("sale_group_name not in", values, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameBetween(String value1, String value2) {
            addCriterion("sale_group_name between", value1, value2, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotBetween(String value1, String value2) {
            addCriterion("sale_group_name not between", value1, value2, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdIsNull() {
            addCriterion("sale_company_id is null");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdIsNotNull() {
            addCriterion("sale_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdEqualTo(String value) {
            addCriterion("sale_company_id =", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdNotEqualTo(String value) {
            addCriterion("sale_company_id <>", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdGreaterThan(String value) {
            addCriterion("sale_company_id >", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("sale_company_id >=", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdLessThan(String value) {
            addCriterion("sale_company_id <", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("sale_company_id <=", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdLike(String value) {
            addCriterion("sale_company_id like", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdNotLike(String value) {
            addCriterion("sale_company_id not like", value, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdIn(List<String> values) {
            addCriterion("sale_company_id in", values, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdNotIn(List<String> values) {
            addCriterion("sale_company_id not in", values, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdBetween(String value1, String value2) {
            addCriterion("sale_company_id between", value1, value2, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyIdNotBetween(String value1, String value2) {
            addCriterion("sale_company_id not between", value1, value2, "saleCompanyId");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameIsNull() {
            addCriterion("sale_company_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameIsNotNull() {
            addCriterion("sale_company_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameEqualTo(String value) {
            addCriterion("sale_company_name =", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameNotEqualTo(String value) {
            addCriterion("sale_company_name <>", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameGreaterThan(String value) {
            addCriterion("sale_company_name >", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_company_name >=", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameLessThan(String value) {
            addCriterion("sale_company_name <", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("sale_company_name <=", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameLike(String value) {
            addCriterion("sale_company_name like", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameNotLike(String value) {
            addCriterion("sale_company_name not like", value, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameIn(List<String> values) {
            addCriterion("sale_company_name in", values, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameNotIn(List<String> values) {
            addCriterion("sale_company_name not in", values, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameBetween(String value1, String value2) {
            addCriterion("sale_company_name between", value1, value2, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andSaleCompanyNameNotBetween(String value1, String value2) {
            addCriterion("sale_company_name not between", value1, value2, "saleCompanyName");
            return (Criteria) this;
        }

        public Criteria andOrgIsNull() {
            addCriterion("org is null");
            return (Criteria) this;
        }

        public Criteria andOrgIsNotNull() {
            addCriterion("org is not null");
            return (Criteria) this;
        }

        public Criteria andOrgEqualTo(String value) {
            addCriterion("org =", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgNotEqualTo(String value) {
            addCriterion("org <>", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgGreaterThan(String value) {
            addCriterion("org >", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgGreaterThanOrEqualTo(String value) {
            addCriterion("org >=", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgLessThan(String value) {
            addCriterion("org <", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgLessThanOrEqualTo(String value) {
            addCriterion("org <=", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgLike(String value) {
            addCriterion("org like", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgNotLike(String value) {
            addCriterion("org not like", value, "org");
            return (Criteria) this;
        }

        public Criteria andOrgIn(List<String> values) {
            addCriterion("org in", values, "org");
            return (Criteria) this;
        }

        public Criteria andOrgNotIn(List<String> values) {
            addCriterion("org not in", values, "org");
            return (Criteria) this;
        }

        public Criteria andOrgBetween(String value1, String value2) {
            addCriterion("org between", value1, value2, "org");
            return (Criteria) this;
        }

        public Criteria andOrgNotBetween(String value1, String value2) {
            addCriterion("org not between", value1, value2, "org");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIsNull() {
            addCriterion("pallet_merchant is null");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIsNotNull() {
            addCriterion("pallet_merchant is not null");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantEqualTo(String value) {
            addCriterion("pallet_merchant =", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotEqualTo(String value) {
            addCriterion("pallet_merchant <>", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantGreaterThan(String value) {
            addCriterion("pallet_merchant >", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantGreaterThanOrEqualTo(String value) {
            addCriterion("pallet_merchant >=", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLessThan(String value) {
            addCriterion("pallet_merchant <", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLessThanOrEqualTo(String value) {
            addCriterion("pallet_merchant <=", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLike(String value) {
            addCriterion("pallet_merchant like", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotLike(String value) {
            addCriterion("pallet_merchant not like", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIn(List<String> values) {
            addCriterion("pallet_merchant in", values, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotIn(List<String> values) {
            addCriterion("pallet_merchant not in", values, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantBetween(String value1, String value2) {
            addCriterion("pallet_merchant between", value1, value2, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotBetween(String value1, String value2) {
            addCriterion("pallet_merchant not between", value1, value2, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNull() {
            addCriterion("pay_method is null");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNotNull() {
            addCriterion("pay_method is not null");
            return (Criteria) this;
        }

        public Criteria andPayMethodEqualTo(String value) {
            addCriterion("pay_method =", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotEqualTo(String value) {
            addCriterion("pay_method <>", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThan(String value) {
            addCriterion("pay_method >", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThanOrEqualTo(String value) {
            addCriterion("pay_method >=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThan(String value) {
            addCriterion("pay_method <", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThanOrEqualTo(String value) {
            addCriterion("pay_method <=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLike(String value) {
            addCriterion("pay_method like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotLike(String value) {
            addCriterion("pay_method not like", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodIn(List<String> values) {
            addCriterion("pay_method in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotIn(List<String> values) {
            addCriterion("pay_method not in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodBetween(String value1, String value2) {
            addCriterion("pay_method between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotBetween(String value1, String value2) {
            addCriterion("pay_method not between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andCashIsNull() {
            addCriterion("cash is null");
            return (Criteria) this;
        }

        public Criteria andCashIsNotNull() {
            addCriterion("cash is not null");
            return (Criteria) this;
        }

        public Criteria andCashEqualTo(BigDecimal value) {
            addCriterion("cash =", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotEqualTo(BigDecimal value) {
            addCriterion("cash <>", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashGreaterThan(BigDecimal value) {
            addCriterion("cash >", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cash >=", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashLessThan(BigDecimal value) {
            addCriterion("cash <", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cash <=", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashIn(List<BigDecimal> values) {
            addCriterion("cash in", values, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotIn(List<BigDecimal> values) {
            addCriterion("cash not in", values, "cash");
            return (Criteria) this;
        }

        public Criteria andCashBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cash between", value1, value2, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cash not between", value1, value2, "cash");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("currency is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("currency is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("currency =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("currency <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("currency >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("currency >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("currency <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("currency <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("currency like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("currency not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("currency in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("currency not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("currency between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("currency not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIsNull() {
            addCriterion("exchange_rate is null");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIsNotNull() {
            addCriterion("exchange_rate is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeRateEqualTo(BigDecimal value) {
            addCriterion("exchange_rate =", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotEqualTo(BigDecimal value) {
            addCriterion("exchange_rate <>", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateGreaterThan(BigDecimal value) {
            addCriterion("exchange_rate >", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("exchange_rate >=", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateLessThan(BigDecimal value) {
            addCriterion("exchange_rate <", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("exchange_rate <=", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIn(List<BigDecimal> values) {
            addCriterion("exchange_rate in", values, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotIn(List<BigDecimal> values) {
            addCriterion("exchange_rate not in", values, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("exchange_rate between", value1, value2, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("exchange_rate not between", value1, value2, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(String value) {
            addCriterion("tax_rate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(String value) {
            addCriterion("tax_rate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(String value) {
            addCriterion("tax_rate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(String value) {
            addCriterion("tax_rate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(String value) {
            addCriterion("tax_rate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(String value) {
            addCriterion("tax_rate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLike(String value) {
            addCriterion("tax_rate like", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotLike(String value) {
            addCriterion("tax_rate not like", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<String> values) {
            addCriterion("tax_rate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<String> values) {
            addCriterion("tax_rate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(String value1, String value2) {
            addCriterion("tax_rate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(String value1, String value2) {
            addCriterion("tax_rate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2IsNull() {
            addCriterion("delivery_tolerance2 is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2IsNotNull() {
            addCriterion("delivery_tolerance2 is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2EqualTo(String value) {
            addCriterion("delivery_tolerance2 =", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2NotEqualTo(String value) {
            addCriterion("delivery_tolerance2 <>", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2GreaterThan(String value) {
            addCriterion("delivery_tolerance2 >", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2GreaterThanOrEqualTo(String value) {
            addCriterion("delivery_tolerance2 >=", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2LessThan(String value) {
            addCriterion("delivery_tolerance2 <", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2LessThanOrEqualTo(String value) {
            addCriterion("delivery_tolerance2 <=", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2Like(String value) {
            addCriterion("delivery_tolerance2 like", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2NotLike(String value) {
            addCriterion("delivery_tolerance2 not like", value, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2In(List<String> values) {
            addCriterion("delivery_tolerance2 in", values, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2NotIn(List<String> values) {
            addCriterion("delivery_tolerance2 not in", values, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2Between(String value1, String value2) {
            addCriterion("delivery_tolerance2 between", value1, value2, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance2NotBetween(String value1, String value2) {
            addCriterion("delivery_tolerance2 not between", value1, value2, "deliveryTolerance2");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1IsNull() {
            addCriterion("delivery_tolerance1 is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1IsNotNull() {
            addCriterion("delivery_tolerance1 is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1EqualTo(String value) {
            addCriterion("delivery_tolerance1 =", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1NotEqualTo(String value) {
            addCriterion("delivery_tolerance1 <>", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1GreaterThan(String value) {
            addCriterion("delivery_tolerance1 >", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1GreaterThanOrEqualTo(String value) {
            addCriterion("delivery_tolerance1 >=", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1LessThan(String value) {
            addCriterion("delivery_tolerance1 <", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1LessThanOrEqualTo(String value) {
            addCriterion("delivery_tolerance1 <=", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1Like(String value) {
            addCriterion("delivery_tolerance1 like", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1NotLike(String value) {
            addCriterion("delivery_tolerance1 not like", value, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1In(List<String> values) {
            addCriterion("delivery_tolerance1 in", values, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1NotIn(List<String> values) {
            addCriterion("delivery_tolerance1 not in", values, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1Between(String value1, String value2) {
            addCriterion("delivery_tolerance1 between", value1, value2, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andDeliveryTolerance1NotBetween(String value1, String value2) {
            addCriterion("delivery_tolerance1 not between", value1, value2, "deliveryTolerance1");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateIsNull() {
            addCriterion("payment_collection_date is null");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateIsNotNull() {
            addCriterion("payment_collection_date is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateEqualTo(String value) {
            addCriterion("payment_collection_date =", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateNotEqualTo(String value) {
            addCriterion("payment_collection_date <>", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateGreaterThan(String value) {
            addCriterion("payment_collection_date >", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateGreaterThanOrEqualTo(String value) {
            addCriterion("payment_collection_date >=", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateLessThan(String value) {
            addCriterion("payment_collection_date <", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateLessThanOrEqualTo(String value) {
            addCriterion("payment_collection_date <=", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateLike(String value) {
            addCriterion("payment_collection_date like", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateNotLike(String value) {
            addCriterion("payment_collection_date not like", value, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateIn(List<String> values) {
            addCriterion("payment_collection_date in", values, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateNotIn(List<String> values) {
            addCriterion("payment_collection_date not in", values, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateBetween(String value1, String value2) {
            addCriterion("payment_collection_date between", value1, value2, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andPaymentCollectionDateNotBetween(String value1, String value2) {
            addCriterion("payment_collection_date not between", value1, value2, "paymentCollectionDate");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNull() {
            addCriterion("contract_status is null");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNotNull() {
            addCriterion("contract_status is not null");
            return (Criteria) this;
        }

        public Criteria andContractStatusEqualTo(Integer value) {
            addCriterion("contract_status =", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotEqualTo(Integer value) {
            addCriterion("contract_status <>", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThan(Integer value) {
            addCriterion("contract_status >", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_status >=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThan(Integer value) {
            addCriterion("contract_status <", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThanOrEqualTo(Integer value) {
            addCriterion("contract_status <=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusIn(List<Integer> values) {
            addCriterion("contract_status in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotIn(List<Integer> values) {
            addCriterion("contract_status not in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusBetween(Integer value1, Integer value2) {
            addCriterion("contract_status between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_status not between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountIsNull() {
            addCriterion("totaltaxamount is null");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountIsNotNull() {
            addCriterion("totaltaxamount is not null");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountEqualTo(BigDecimal value) {
            addCriterion("totaltaxamount =", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountNotEqualTo(BigDecimal value) {
            addCriterion("totaltaxamount <>", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountGreaterThan(BigDecimal value) {
            addCriterion("totaltaxamount >", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("totaltaxamount >=", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountLessThan(BigDecimal value) {
            addCriterion("totaltaxamount <", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("totaltaxamount <=", value, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountIn(List<BigDecimal> values) {
            addCriterion("totaltaxamount in", values, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountNotIn(List<BigDecimal> values) {
            addCriterion("totaltaxamount not in", values, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("totaltaxamount between", value1, value2, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andTotaltaxamountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("totaltaxamount not between", value1, value2, "totaltaxamount");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("category_id is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("category_id is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(Integer value) {
            addCriterion("category_id =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(Integer value) {
            addCriterion("category_id <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(Integer value) {
            addCriterion("category_id >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("category_id >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(Integer value) {
            addCriterion("category_id <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("category_id <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<Integer> values) {
            addCriterion("category_id in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<Integer> values) {
            addCriterion("category_id not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("category_id between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("category_id not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryNameIsNull() {
            addCriterion("category_name is null");
            return (Criteria) this;
        }

        public Criteria andCategoryNameIsNotNull() {
            addCriterion("category_name is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryNameEqualTo(String value) {
            addCriterion("category_name =", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameNotEqualTo(String value) {
            addCriterion("category_name <>", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameGreaterThan(String value) {
            addCriterion("category_name >", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameGreaterThanOrEqualTo(String value) {
            addCriterion("category_name >=", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameLessThan(String value) {
            addCriterion("category_name <", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameLessThanOrEqualTo(String value) {
            addCriterion("category_name <=", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameLike(String value) {
            addCriterion("category_name like", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameNotLike(String value) {
            addCriterion("category_name not like", value, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameIn(List<String> values) {
            addCriterion("category_name in", values, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameNotIn(List<String> values) {
            addCriterion("category_name not in", values, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameBetween(String value1, String value2) {
            addCriterion("category_name between", value1, value2, "categoryName");
            return (Criteria) this;
        }

        public Criteria andCategoryNameNotBetween(String value1, String value2) {
            addCriterion("category_name not between", value1, value2, "categoryName");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderIsNull() {
            addCriterion("is_shop_order is null");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderIsNotNull() {
            addCriterion("is_shop_order is not null");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderEqualTo(Integer value) {
            addCriterion("is_shop_order =", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderNotEqualTo(Integer value) {
            addCriterion("is_shop_order <>", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderGreaterThan(Integer value) {
            addCriterion("is_shop_order >", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_shop_order >=", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderLessThan(Integer value) {
            addCriterion("is_shop_order <", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderLessThanOrEqualTo(Integer value) {
            addCriterion("is_shop_order <=", value, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderIn(List<Integer> values) {
            addCriterion("is_shop_order in", values, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderNotIn(List<Integer> values) {
            addCriterion("is_shop_order not in", values, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderBetween(Integer value1, Integer value2) {
            addCriterion("is_shop_order between", value1, value2, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andIsShopOrderNotBetween(Integer value1, Integer value2) {
            addCriterion("is_shop_order not between", value1, value2, "isShopOrder");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameIsNull() {
            addCriterion("sales_cust_name is null");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameIsNotNull() {
            addCriterion("sales_cust_name is not null");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameEqualTo(String value) {
            addCriterion("sales_cust_name =", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameNotEqualTo(String value) {
            addCriterion("sales_cust_name <>", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameGreaterThan(String value) {
            addCriterion("sales_cust_name >", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameGreaterThanOrEqualTo(String value) {
            addCriterion("sales_cust_name >=", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameLessThan(String value) {
            addCriterion("sales_cust_name <", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameLessThanOrEqualTo(String value) {
            addCriterion("sales_cust_name <=", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameLike(String value) {
            addCriterion("sales_cust_name like", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameNotLike(String value) {
            addCriterion("sales_cust_name not like", value, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameIn(List<String> values) {
            addCriterion("sales_cust_name in", values, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameNotIn(List<String> values) {
            addCriterion("sales_cust_name not in", values, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameBetween(String value1, String value2) {
            addCriterion("sales_cust_name between", value1, value2, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andSalesCustNameNotBetween(String value1, String value2) {
            addCriterion("sales_cust_name not between", value1, value2, "salesCustName");
            return (Criteria) this;
        }

        public Criteria andPayPriceIsNull() {
            addCriterion("pay_price is null");
            return (Criteria) this;
        }

        public Criteria andPayPriceIsNotNull() {
            addCriterion("pay_price is not null");
            return (Criteria) this;
        }

        public Criteria andPayPriceEqualTo(BigDecimal value) {
            addCriterion("pay_price =", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotEqualTo(BigDecimal value) {
            addCriterion("pay_price <>", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceGreaterThan(BigDecimal value) {
            addCriterion("pay_price >", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_price >=", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceLessThan(BigDecimal value) {
            addCriterion("pay_price <", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_price <=", value, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceIn(List<BigDecimal> values) {
            addCriterion("pay_price in", values, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotIn(List<BigDecimal> values) {
            addCriterion("pay_price not in", values, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_price between", value1, value2, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_price not between", value1, value2, "payPrice");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNull() {
            addCriterion("pay_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNotNull() {
            addCriterion("pay_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee =", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <>", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("pay_total_fee >", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee >=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThan(BigDecimal value) {
            addCriterion("pay_total_fee <", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee not in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee not between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIsNull() {
            addCriterion("total_amount is null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIsNotNull() {
            addCriterion("total_amount is not null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountEqualTo(BigDecimal value) {
            addCriterion("total_amount =", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountNotEqualTo(BigDecimal value) {
            addCriterion("total_amount <>", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountGreaterThan(BigDecimal value) {
            addCriterion("total_amount >", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_amount >=", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountLessThan(BigDecimal value) {
            addCriterion("total_amount <", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_amount <=", value, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountIn(List<BigDecimal> values) {
            addCriterion("total_amount in", values, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountNotIn(List<BigDecimal> values) {
            addCriterion("total_amount not in", values, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_amount between", value1, value2, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_amount not between", value1, value2, "totalAmount");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNull() {
            addCriterion("total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNotNull() {
            addCriterion("total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeEqualTo(BigDecimal value) {
            addCriterion("total_fee =", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("total_fee <>", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("total_fee >", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee >=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThan(BigDecimal value) {
            addCriterion("total_fee <", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee <=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIn(List<BigDecimal> values) {
            addCriterion("total_fee in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("total_fee not in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee not between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalWeightIsNull() {
            addCriterion("total_weight is null");
            return (Criteria) this;
        }

        public Criteria andTotalWeightIsNotNull() {
            addCriterion("total_weight is not null");
            return (Criteria) this;
        }

        public Criteria andTotalWeightEqualTo(BigDecimal value) {
            addCriterion("total_weight =", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightNotEqualTo(BigDecimal value) {
            addCriterion("total_weight <>", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightGreaterThan(BigDecimal value) {
            addCriterion("total_weight >", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_weight >=", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightLessThan(BigDecimal value) {
            addCriterion("total_weight <", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_weight <=", value, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightIn(List<BigDecimal> values) {
            addCriterion("total_weight in", values, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightNotIn(List<BigDecimal> values) {
            addCriterion("total_weight not in", values, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_weight between", value1, value2, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andTotalWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_weight not between", value1, value2, "totalWeight");
            return (Criteria) this;
        }

        public Criteria andAddUserIsNull() {
            addCriterion("add_user is null");
            return (Criteria) this;
        }

        public Criteria andAddUserIsNotNull() {
            addCriterion("add_user is not null");
            return (Criteria) this;
        }

        public Criteria andAddUserEqualTo(String value) {
            addCriterion("add_user =", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserNotEqualTo(String value) {
            addCriterion("add_user <>", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserGreaterThan(String value) {
            addCriterion("add_user >", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserGreaterThanOrEqualTo(String value) {
            addCriterion("add_user >=", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserLessThan(String value) {
            addCriterion("add_user <", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserLessThanOrEqualTo(String value) {
            addCriterion("add_user <=", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserLike(String value) {
            addCriterion("add_user like", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserNotLike(String value) {
            addCriterion("add_user not like", value, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserIn(List<String> values) {
            addCriterion("add_user in", values, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserNotIn(List<String> values) {
            addCriterion("add_user not in", values, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserBetween(String value1, String value2) {
            addCriterion("add_user between", value1, value2, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddUserNotBetween(String value1, String value2) {
            addCriterion("add_user not between", value1, value2, "addUser");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(Date value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(Date value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(Date value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(Date value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<Date> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<Date> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(Date value1, Date value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andStoreCodeIsNull() {
            addCriterion("store_code is null");
            return (Criteria) this;
        }

        public Criteria andStoreCodeIsNotNull() {
            addCriterion("store_code is not null");
            return (Criteria) this;
        }

        public Criteria andStoreCodeEqualTo(String value) {
            addCriterion("store_code =", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeNotEqualTo(String value) {
            addCriterion("store_code <>", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeGreaterThan(String value) {
            addCriterion("store_code >", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeGreaterThanOrEqualTo(String value) {
            addCriterion("store_code >=", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeLessThan(String value) {
            addCriterion("store_code <", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeLessThanOrEqualTo(String value) {
            addCriterion("store_code <=", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeLike(String value) {
            addCriterion("store_code like", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeNotLike(String value) {
            addCriterion("store_code not like", value, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeIn(List<String> values) {
            addCriterion("store_code in", values, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeNotIn(List<String> values) {
            addCriterion("store_code not in", values, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeBetween(String value1, String value2) {
            addCriterion("store_code between", value1, value2, "storeCode");
            return (Criteria) this;
        }

        public Criteria andStoreCodeNotBetween(String value1, String value2) {
            addCriterion("store_code not between", value1, value2, "storeCode");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("memo not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("company_id is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("company_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(String value) {
            addCriterion("company_id =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(String value) {
            addCriterion("company_id <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(String value) {
            addCriterion("company_id >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("company_id >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(String value) {
            addCriterion("company_id <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("company_id <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLike(String value) {
            addCriterion("company_id like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotLike(String value) {
            addCriterion("company_id not like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<String> values) {
            addCriterion("company_id in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<String> values) {
            addCriterion("company_id not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(String value1, String value2) {
            addCriterion("company_id between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(String value1, String value2) {
            addCriterion("company_id not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andReviewerIsNull() {
            addCriterion("reviewer is null");
            return (Criteria) this;
        }

        public Criteria andReviewerIsNotNull() {
            addCriterion("reviewer is not null");
            return (Criteria) this;
        }

        public Criteria andReviewerEqualTo(String value) {
            addCriterion("reviewer =", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerNotEqualTo(String value) {
            addCriterion("reviewer <>", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerGreaterThan(String value) {
            addCriterion("reviewer >", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerGreaterThanOrEqualTo(String value) {
            addCriterion("reviewer >=", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerLessThan(String value) {
            addCriterion("reviewer <", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerLessThanOrEqualTo(String value) {
            addCriterion("reviewer <=", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerLike(String value) {
            addCriterion("reviewer like", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerNotLike(String value) {
            addCriterion("reviewer not like", value, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerIn(List<String> values) {
            addCriterion("reviewer in", values, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerNotIn(List<String> values) {
            addCriterion("reviewer not in", values, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerBetween(String value1, String value2) {
            addCriterion("reviewer between", value1, value2, "reviewer");
            return (Criteria) this;
        }

        public Criteria andReviewerNotBetween(String value1, String value2) {
            addCriterion("reviewer not between", value1, value2, "reviewer");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andZgStatusIsNull() {
            addCriterion("zg_status is null");
            return (Criteria) this;
        }

        public Criteria andZgStatusIsNotNull() {
            addCriterion("zg_status is not null");
            return (Criteria) this;
        }

        public Criteria andZgStatusEqualTo(String value) {
            addCriterion("zg_status =", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusNotEqualTo(String value) {
            addCriterion("zg_status <>", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusGreaterThan(String value) {
            addCriterion("zg_status >", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusGreaterThanOrEqualTo(String value) {
            addCriterion("zg_status >=", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusLessThan(String value) {
            addCriterion("zg_status <", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusLessThanOrEqualTo(String value) {
            addCriterion("zg_status <=", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusLike(String value) {
            addCriterion("zg_status like", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusNotLike(String value) {
            addCriterion("zg_status not like", value, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusIn(List<String> values) {
            addCriterion("zg_status in", values, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusNotIn(List<String> values) {
            addCriterion("zg_status not in", values, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusBetween(String value1, String value2) {
            addCriterion("zg_status between", value1, value2, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andZgStatusNotBetween(String value1, String value2) {
            addCriterion("zg_status not between", value1, value2, "zgStatus");
            return (Criteria) this;
        }

        public Criteria andChangeReasonIsNull() {
            addCriterion("change_reason is null");
            return (Criteria) this;
        }

        public Criteria andChangeReasonIsNotNull() {
            addCriterion("change_reason is not null");
            return (Criteria) this;
        }

        public Criteria andChangeReasonEqualTo(String value) {
            addCriterion("change_reason =", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonNotEqualTo(String value) {
            addCriterion("change_reason <>", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonGreaterThan(String value) {
            addCriterion("change_reason >", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonGreaterThanOrEqualTo(String value) {
            addCriterion("change_reason >=", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonLessThan(String value) {
            addCriterion("change_reason <", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonLessThanOrEqualTo(String value) {
            addCriterion("change_reason <=", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonLike(String value) {
            addCriterion("change_reason like", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonNotLike(String value) {
            addCriterion("change_reason not like", value, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonIn(List<String> values) {
            addCriterion("change_reason in", values, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonNotIn(List<String> values) {
            addCriterion("change_reason not in", values, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonBetween(String value1, String value2) {
            addCriterion("change_reason between", value1, value2, "changeReason");
            return (Criteria) this;
        }

        public Criteria andChangeReasonNotBetween(String value1, String value2) {
            addCriterion("change_reason not between", value1, value2, "changeReason");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightIsNull() {
            addCriterion("purchased_weight is null");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightIsNotNull() {
            addCriterion("purchased_weight is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightEqualTo(BigDecimal value) {
            addCriterion("purchased_weight =", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightNotEqualTo(BigDecimal value) {
            addCriterion("purchased_weight <>", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightGreaterThan(BigDecimal value) {
            addCriterion("purchased_weight >", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("purchased_weight >=", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightLessThan(BigDecimal value) {
            addCriterion("purchased_weight <", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("purchased_weight <=", value, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightIn(List<BigDecimal> values) {
            addCriterion("purchased_weight in", values, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightNotIn(List<BigDecimal> values) {
            addCriterion("purchased_weight not in", values, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("purchased_weight between", value1, value2, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andPurchasedWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("purchased_weight not between", value1, value2, "purchasedWeight");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIsNull() {
            addCriterion("amount_money is null");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIsNotNull() {
            addCriterion("amount_money is not null");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyEqualTo(BigDecimal value) {
            addCriterion("amount_money =", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotEqualTo(BigDecimal value) {
            addCriterion("amount_money <>", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyGreaterThan(BigDecimal value) {
            addCriterion("amount_money >", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount_money >=", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyLessThan(BigDecimal value) {
            addCriterion("amount_money <", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount_money <=", value, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyIn(List<BigDecimal> values) {
            addCriterion("amount_money in", values, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotIn(List<BigDecimal> values) {
            addCriterion("amount_money not in", values, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount_money between", value1, value2, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andAmountMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount_money not between", value1, value2, "amountMoney");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermIsNull() {
            addCriterion("before_chg_term is null");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermIsNotNull() {
            addCriterion("before_chg_term is not null");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermEqualTo(String value) {
            addCriterion("before_chg_term =", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermNotEqualTo(String value) {
            addCriterion("before_chg_term <>", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermGreaterThan(String value) {
            addCriterion("before_chg_term >", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermGreaterThanOrEqualTo(String value) {
            addCriterion("before_chg_term >=", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermLessThan(String value) {
            addCriterion("before_chg_term <", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermLessThanOrEqualTo(String value) {
            addCriterion("before_chg_term <=", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermLike(String value) {
            addCriterion("before_chg_term like", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermNotLike(String value) {
            addCriterion("before_chg_term not like", value, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermIn(List<String> values) {
            addCriterion("before_chg_term in", values, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermNotIn(List<String> values) {
            addCriterion("before_chg_term not in", values, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermBetween(String value1, String value2) {
            addCriterion("before_chg_term between", value1, value2, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andBeforeChgTermNotBetween(String value1, String value2) {
            addCriterion("before_chg_term not between", value1, value2, "beforeChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermIsNull() {
            addCriterion("after_chg_term is null");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermIsNotNull() {
            addCriterion("after_chg_term is not null");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermEqualTo(String value) {
            addCriterion("after_chg_term =", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermNotEqualTo(String value) {
            addCriterion("after_chg_term <>", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermGreaterThan(String value) {
            addCriterion("after_chg_term >", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermGreaterThanOrEqualTo(String value) {
            addCriterion("after_chg_term >=", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermLessThan(String value) {
            addCriterion("after_chg_term <", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermLessThanOrEqualTo(String value) {
            addCriterion("after_chg_term <=", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermLike(String value) {
            addCriterion("after_chg_term like", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermNotLike(String value) {
            addCriterion("after_chg_term not like", value, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermIn(List<String> values) {
            addCriterion("after_chg_term in", values, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermNotIn(List<String> values) {
            addCriterion("after_chg_term not in", values, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermBetween(String value1, String value2) {
            addCriterion("after_chg_term between", value1, value2, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andAfterChgTermNotBetween(String value1, String value2) {
            addCriterion("after_chg_term not between", value1, value2, "afterChgTerm");
            return (Criteria) this;
        }

        public Criteria andContractTemplateIsNull() {
            addCriterion("contract_template is null");
            return (Criteria) this;
        }

        public Criteria andContractTemplateIsNotNull() {
            addCriterion("contract_template is not null");
            return (Criteria) this;
        }

        public Criteria andContractTemplateEqualTo(String value) {
            addCriterion("contract_template =", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateNotEqualTo(String value) {
            addCriterion("contract_template <>", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateGreaterThan(String value) {
            addCriterion("contract_template >", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateGreaterThanOrEqualTo(String value) {
            addCriterion("contract_template >=", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateLessThan(String value) {
            addCriterion("contract_template <", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateLessThanOrEqualTo(String value) {
            addCriterion("contract_template <=", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateLike(String value) {
            addCriterion("contract_template like", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateNotLike(String value) {
            addCriterion("contract_template not like", value, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateIn(List<String> values) {
            addCriterion("contract_template in", values, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateNotIn(List<String> values) {
            addCriterion("contract_template not in", values, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateBetween(String value1, String value2) {
            addCriterion("contract_template between", value1, value2, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andContractTemplateNotBetween(String value1, String value2) {
            addCriterion("contract_template not between", value1, value2, "contractTemplate");
            return (Criteria) this;
        }

        public Criteria andSettleTermIsNull() {
            addCriterion("settle_term is null");
            return (Criteria) this;
        }

        public Criteria andSettleTermIsNotNull() {
            addCriterion("settle_term is not null");
            return (Criteria) this;
        }

        public Criteria andSettleTermEqualTo(String value) {
            addCriterion("settle_term =", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermNotEqualTo(String value) {
            addCriterion("settle_term <>", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermGreaterThan(String value) {
            addCriterion("settle_term >", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermGreaterThanOrEqualTo(String value) {
            addCriterion("settle_term >=", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermLessThan(String value) {
            addCriterion("settle_term <", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermLessThanOrEqualTo(String value) {
            addCriterion("settle_term <=", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermLike(String value) {
            addCriterion("settle_term like", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermNotLike(String value) {
            addCriterion("settle_term not like", value, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermIn(List<String> values) {
            addCriterion("settle_term in", values, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermNotIn(List<String> values) {
            addCriterion("settle_term not in", values, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermBetween(String value1, String value2) {
            addCriterion("settle_term between", value1, value2, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andSettleTermNotBetween(String value1, String value2) {
            addCriterion("settle_term not between", value1, value2, "settleTerm");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthIsNull() {
            addCriterion("contract_data_month is null");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthIsNotNull() {
            addCriterion("contract_data_month is not null");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthEqualTo(String value) {
            addCriterion("contract_data_month =", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthNotEqualTo(String value) {
            addCriterion("contract_data_month <>", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthGreaterThan(String value) {
            addCriterion("contract_data_month >", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthGreaterThanOrEqualTo(String value) {
            addCriterion("contract_data_month >=", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthLessThan(String value) {
            addCriterion("contract_data_month <", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthLessThanOrEqualTo(String value) {
            addCriterion("contract_data_month <=", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthLike(String value) {
            addCriterion("contract_data_month like", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthNotLike(String value) {
            addCriterion("contract_data_month not like", value, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthIn(List<String> values) {
            addCriterion("contract_data_month in", values, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthNotIn(List<String> values) {
            addCriterion("contract_data_month not in", values, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthBetween(String value1, String value2) {
            addCriterion("contract_data_month between", value1, value2, "contractDataMonth");
            return (Criteria) this;
        }

        public Criteria andContractDataMonthNotBetween(String value1, String value2) {
            addCriterion("contract_data_month not between", value1, value2, "contractDataMonth");
            return (Criteria) this;
        }
    }

    /**
     * framework_contract_info
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title framework_contract_info表的实体类
     * @description framework_contract_info
     * @version 1.0
     * @author may
     * @date 2021-05-21 09:40:50
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
